'Declaration
Public Overloads Function Add( _ ByVal rangeRefs() As Reference, _ ByVal type As DataValidationType, _ ByVal errorStyle As DataValidationErrorStyle, _ ByVal operator As DataValidationOperator, _ ByVal formula1 As String, _ Optional ByVal formula2 As String _ ) As DataValidation
'Usage
Dim instance As DataValidationManager Dim rangeRefs() As Reference Dim type As DataValidationType Dim errorStyle As DataValidationErrorStyle Dim operator As DataValidationOperator Dim formula1 As String Dim formula2 As String Dim value As DataValidation value = instance.Add(rangeRefs, type, errorStyle, operator, formula1, formula2)
Parameters
- rangeRefs
- An array of GrapeCity.Spreadsheet.Reference indicates the references of this GrapeCity.Spreadsheet.DataValidation.
- type
- A GrapeCity.Spreadsheet.DataValidationType value indicates the type of data validation to add.
- errorStyle
- A GrapeCity.Spreadsheet.DataValidationErrorStyle value indicates the error style to use for error messages.
- operator
- formula1
- A string value indicates the first data validation value, formula or list.
- formula2
- A string value indicates the second data validation value for GrapeCity.Spreadsheet.DataValidationOperator.Between or GrapeCity.Spreadsheet.DataValidationOperator.NotBetween.
Return Value
A GrapeCity.Spreadsheet.DataValidation instance represents the created data validation.
null
if the data is invalid.